Overview

Dataset statistics

Number of variables17
Number of observations267613
Missing cells84101
Missing cells (%)1.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory34.7 MiB
Average record size in memory136.0 B

Variable types

Numeric5
Text8
Categorical3
DateTime1

Alerts

State is highly imbalanced (> 99.9%)Imbalance
Facility Type has 5117 (1.9%) missing valuesMissing
Violations has 73370 (27.4%) missing valuesMissing
Zip is highly skewed (γ1 = -111.1847108)Skewed
Inspection ID has unique valuesUnique

Reproduction

Analysis started2024-02-22 14:53:49.204240
Analysis finished2024-02-22 14:55:08.030369
Duration1 minute and 18.83 seconds
Software versionydata-profiling vv4.6.4
Download configurationconfig.json

Variables

Inspection ID
Real number (ℝ)

UNIQUE 

Distinct267613
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1729978.2
Minimum44247
Maximum2589576
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 MiB
2024-02-22T09:55:08.167643image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum44247
5-th percentile327242.6
Q11307372
median1950872
Q32357009
95-th percentile2575772.4
Maximum2589576
Range2545329
Interquartile range (IQR)1049637

Descriptive statistics

Standard deviation719480.58
Coefficient of variation (CV)0.41588997
Kurtosis-0.65207757
Mean1729978.2
Median Absolute Deviation (MAD)547189
Skewness-0.62808136
Sum4.6296466 × 1011
Variance5.1765231 × 1011
MonotonicityNot monotonic
2024-02-22T09:55:08.368001image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2589576 1
 
< 0.1%
1527396 1
 
< 0.1%
1199760 1
 
< 0.1%
1527646 1
 
< 0.1%
1532257 1
 
< 0.1%
1439668 1
 
< 0.1%
1532231 1
 
< 0.1%
1453831 1
 
< 0.1%
1515865 1
 
< 0.1%
1516015 1
 
< 0.1%
Other values (267603) 267603
> 99.9%
ValueCountFrequency (%)
44247 1
< 0.1%
44248 1
< 0.1%
44249 1
< 0.1%
44250 1
< 0.1%
44251 1
< 0.1%
44252 1
< 0.1%
44253 1
< 0.1%
44254 1
< 0.1%
44255 1
< 0.1%
44256 1
< 0.1%
ValueCountFrequency (%)
2589576 1
< 0.1%
2589573 1
< 0.1%
2589562 1
< 0.1%
2589555 1
< 0.1%
2589553 1
< 0.1%
2589551 1
< 0.1%
2589549 1
< 0.1%
2589547 1
< 0.1%
2589536 1
< 0.1%
2589535 1
< 0.1%
Distinct32172
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Memory size2.0 MiB
2024-02-22T09:55:09.057871image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length79
Median length49
Mean length18.731732
Min length1

Characters and Unicode

Total characters5012855
Distinct characters83
Distinct categories12 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5940 ?
Unique (%)2.2%

Sample

1st rowDrippin' Bites
2nd rowGRAND BEER WINE SPIRITS
3rd rowCASA CENTRAL COMMUNITY SERVICE
4th rowBARTOLI'S PIZZERIA
5th rowLUNCH HEROS
ValueCountFrequency (%)
inc 27081
 
3.3%
26487
 
3.3%
restaurant 15485
 
1.9%
food 11424
 
1.4%
the 10940
 
1.3%
cafe 8793
 
1.1%
chicago 7633
 
0.9%
grill 7326
 
0.9%
and 6538
 
0.8%
pizza 6466
 
0.8%
Other values (18945) 685461
84.2%
2024-02-22T09:55:09.878190image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
551348
 
11.0%
A 412128
 
8.2%
E 408312
 
8.1%
R 299407
 
6.0%
I 289373
 
5.8%
O 286438
 
5.7%
N 279069
 
5.6%
S 275615
 
5.5%
T 247516
 
4.9%
C 232589
 
4.6%
Other values (73) 1731060
34.5%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 4052404
80.8%
Space Separator 551348
 
11.0%
Lowercase Letter 195244
 
3.9%
Other Punctuation 126723
 
2.5%
Decimal Number 74780
 
1.5%
Dash Punctuation 9056
 
0.2%
Open Punctuation 1464
 
< 0.1%
Close Punctuation 1464
 
< 0.1%
Math Symbol 337
 
< 0.1%
Connector Punctuation 18
 
< 0.1%
Other values (2) 17
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A 412128
 
10.2%
E 408312
 
10.1%
R 299407
 
7.4%
I 289373
 
7.1%
O 286438
 
7.1%
N 279069
 
6.9%
S 275615
 
6.8%
T 247516
 
6.1%
C 232589
 
5.7%
L 213957
 
5.3%
Other values (16) 1108000
27.3%
Lowercase Letter
ValueCountFrequency (%)
e 23850
12.2%
a 21131
10.8%
o 16427
 
8.4%
n 15966
 
8.2%
r 15298
 
7.8%
i 13719
 
7.0%
l 12234
 
6.3%
t 12141
 
6.2%
s 10360
 
5.3%
c 8074
 
4.1%
Other values (16) 46044
23.6%
Other Punctuation
ValueCountFrequency (%)
' 41710
32.9%
. 24405
19.3%
& 21607
17.1%
, 17293
13.6%
# 15171
 
12.0%
/ 5050
 
4.0%
@ 1047
 
0.8%
! 311
 
0.2%
: 51
 
< 0.1%
? 50
 
< 0.1%
Other values (3) 28
 
< 0.1%
Decimal Number
ValueCountFrequency (%)
2 11339
15.2%
1 11058
14.8%
3 9552
12.8%
7 7537
10.1%
5 7273
9.7%
0 6945
9.3%
4 6541
8.7%
8 5226
7.0%
6 5012
6.7%
9 4297
 
5.7%
Space Separator
ValueCountFrequency (%)
551348
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9056
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1464
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1464
100.0%
Math Symbol
ValueCountFrequency (%)
+ 337
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 18
100.0%
Currency Symbol
ValueCountFrequency (%)
$ 11
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 4247648
84.7%
Common 765207
 
15.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 412128
 
9.7%
E 408312
 
9.6%
R 299407
 
7.0%
I 289373
 
6.8%
O 286438
 
6.7%
N 279069
 
6.6%
S 275615
 
6.5%
T 247516
 
5.8%
C 232589
 
5.5%
L 213957
 
5.0%
Other values (42) 1303244
30.7%
Common
ValueCountFrequency (%)
551348
72.1%
' 41710
 
5.5%
. 24405
 
3.2%
& 21607
 
2.8%
, 17293
 
2.3%
# 15171
 
2.0%
2 11339
 
1.5%
1 11058
 
1.4%
3 9552
 
1.2%
- 9056
 
1.2%
Other values (21) 52668
 
6.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5012855
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
551348
 
11.0%
A 412128
 
8.2%
E 408312
 
8.1%
R 299407
 
6.0%
I 289373
 
5.8%
O 286438
 
5.7%
N 279069
 
5.6%
S 275615
 
5.5%
T 247516
 
4.9%
C 232589
 
4.6%
Other values (73) 1731060
34.5%
Distinct30620
Distinct (%)11.5%
Missing2473
Missing (%)0.9%
Memory size2.0 MiB
2024-02-22T09:55:10.375162image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length79
Median length49
Mean length17.914607
Min length2

Characters and Unicode

Total characters4749879
Distinct characters87
Distinct categories13 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5781 ?
Unique (%)2.2%

Sample

1st rowDrippin' Bites
2nd rowGRAND BEER WINE SPIRITS
3rd rowCASA CENTRAL COMMUNITY SERVICE
4th rowBARTOLI'S PIZZERIA
5th rowLUNCH HEROS
ValueCountFrequency (%)
24606
 
3.2%
restaurant 14774
 
1.9%
inc 12548
 
1.6%
food 11140
 
1.4%
the 10539
 
1.4%
cafe 9471
 
1.2%
grill 7460
 
1.0%
school 6917
 
0.9%
pizza 6609
 
0.9%
la 6335
 
0.8%
Other values (18272) 658075
85.6%
2024-02-22T09:55:11.239101image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
509425
 
10.7%
A 401931
 
8.5%
E 397748
 
8.4%
R 288192
 
6.1%
O 274305
 
5.8%
S 268761
 
5.7%
I 263898
 
5.6%
N 256189
 
5.4%
T 239435
 
5.0%
C 206701
 
4.4%
Other values (77) 1643294
34.6%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 3882922
81.7%
Space Separator 509425
 
10.7%
Lowercase Letter 182248
 
3.8%
Other Punctuation 104674
 
2.2%
Decimal Number 52433
 
1.1%
Dash Punctuation 8802
 
0.2%
Open Punctuation 4482
 
0.1%
Close Punctuation 4460
 
0.1%
Math Symbol 371
 
< 0.1%
Connector Punctuation 31
 
< 0.1%
Other values (3) 31
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 22937
12.6%
a 19520
10.7%
o 15187
 
8.3%
n 14419
 
7.9%
r 14083
 
7.7%
i 12850
 
7.1%
l 12089
 
6.6%
t 11101
 
6.1%
s 9063
 
5.0%
c 7318
 
4.0%
Other values (17) 43681
24.0%
Uppercase Letter
ValueCountFrequency (%)
A 401931
 
10.4%
E 397748
 
10.2%
R 288192
 
7.4%
O 274305
 
7.1%
S 268761
 
6.9%
I 263898
 
6.8%
N 256189
 
6.6%
T 239435
 
6.2%
C 206701
 
5.3%
L 201259
 
5.2%
Other values (16) 1084503
27.9%
Other Punctuation
ValueCountFrequency (%)
' 42773
40.9%
& 20834
19.9%
. 14740
 
14.1%
# 9161
 
8.8%
/ 8033
 
7.7%
, 7982
 
7.6%
@ 738
 
0.7%
! 283
 
0.3%
? 47
 
< 0.1%
: 33
 
< 0.1%
Other values (3) 50
 
< 0.1%
Decimal Number
ValueCountFrequency (%)
1 8994
17.2%
2 8032
15.3%
3 6968
13.3%
7 5638
10.8%
5 4883
9.3%
4 4722
9.0%
0 4486
8.6%
6 3162
 
6.0%
8 2990
 
5.7%
9 2558
 
4.9%
Open Punctuation
ValueCountFrequency (%)
( 4477
99.9%
[ 5
 
0.1%
Close Punctuation
ValueCountFrequency (%)
) 4455
99.9%
] 5
 
0.1%
Space Separator
ValueCountFrequency (%)
509425
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8802
100.0%
Math Symbol
ValueCountFrequency (%)
+ 371
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 31
100.0%
Other Number
ValueCountFrequency (%)
½ 24
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 6
100.0%
Currency Symbol
ValueCountFrequency (%)
$ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 4065170
85.6%
Common 684709
 
14.4%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 401931
 
9.9%
E 397748
 
9.8%
R 288192
 
7.1%
O 274305
 
6.7%
S 268761
 
6.6%
I 263898
 
6.5%
N 256189
 
6.3%
T 239435
 
5.9%
C 206701
 
5.1%
L 201259
 
5.0%
Other values (43) 1266751
31.2%
Common
ValueCountFrequency (%)
509425
74.4%
' 42773
 
6.2%
& 20834
 
3.0%
. 14740
 
2.2%
# 9161
 
1.3%
1 8994
 
1.3%
- 8802
 
1.3%
/ 8033
 
1.2%
2 8032
 
1.2%
, 7982
 
1.2%
Other values (24) 45933
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4749807
> 99.9%
None 72
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
509425
 
10.7%
A 401931
 
8.5%
E 397748
 
8.4%
R 288192
 
6.1%
O 274305
 
5.8%
S 268761
 
5.7%
I 263898
 
5.6%
N 256189
 
5.4%
T 239435
 
5.0%
C 206701
 
4.4%
Other values (74) 1643222
34.6%
None
ValueCountFrequency (%)
½ 24
33.3%
¿ 24
33.3%
ï 24
33.3%

License #
Real number (ℝ)

Distinct44516
Distinct (%)16.6%
Missing18
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean1721820.2
Minimum0
Maximum9999999
Zeros691
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size2.0 MiB
2024-02-22T09:55:11.451176image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile17602
Q11336797
median2048785
Q32369187
95-th percentile2766653.2
Maximum9999999
Range9999999
Interquartile range (IQR)1032390

Descriptive statistics

Standard deviation927017.7
Coefficient of variation (CV)0.53839401
Kurtosis-0.4259452
Mean1721820.2
Median Absolute Deviation (MAD)420446
Skewness-0.89682034
Sum4.6075049 × 1011
Variance8.5936182 × 1011
MonotonicityNot monotonic
2024-02-22T09:55:11.640067image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 691
 
0.3%
1354323 198
 
0.1%
14616 181
 
0.1%
1574001 86
 
< 0.1%
60184 64
 
< 0.1%
2083833 62
 
< 0.1%
1142451 59
 
< 0.1%
1974745 59
 
< 0.1%
1884255 55
 
< 0.1%
1596210 54
 
< 0.1%
Other values (44506) 266086
99.4%
ValueCountFrequency (%)
0 691
0.3%
1 1
 
< 0.1%
2 17
 
< 0.1%
9 15
 
< 0.1%
40 21
 
< 0.1%
43 1
 
< 0.1%
62 18
 
< 0.1%
85 5
 
< 0.1%
99 13
 
< 0.1%
104 1
 
< 0.1%
ValueCountFrequency (%)
9999999 1
 
< 0.1%
8700606 3
< 0.1%
5852857 1
 
< 0.1%
4076132 2
< 0.1%
4075924 2
< 0.1%
4075688 1
 
< 0.1%
4075628 2
< 0.1%
4075597 1
 
< 0.1%
4075446 1
 
< 0.1%
4075357 2
< 0.1%

Facility Type
Text

MISSING 

Distinct513
Distinct (%)0.2%
Missing5117
Missing (%)1.9%
Memory size2.0 MiB
2024-02-22T09:55:12.022845image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length47
Median length10
Mean length11.105381
Min length3

Characters and Unicode

Total characters2915118
Distinct characters69
Distinct categories9 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique73 ?
Unique (%)< 0.1%

Sample

1st rowGrocery Store
2nd rowRestaurant
3rd rowRestaurant
4th rowRestaurant
5th rowSchool
ValueCountFrequency (%)
restaurant 179900
50.6%
store 33658
 
9.5%
grocery 33519
 
9.4%
school 17320
 
4.9%
daycare 7836
 
2.2%
2 7025
 
2.0%
years 7022
 
2.0%
facility 5871
 
1.7%
services 5807
 
1.6%
children's 5723
 
1.6%
Other values (445) 52128
 
14.7%
2024-02-22T09:55:12.543942image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
t 403310
13.8%
a 403088
13.8%
r 328107
11.3%
e 308666
10.6%
s 202928
7.0%
n 201353
6.9%
R 185025
 
6.3%
u 181316
 
6.2%
o 118469
 
4.1%
93327
 
3.2%
Other values (59) 489529
16.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 2409503
82.7%
Uppercase Letter 380991
 
13.1%
Space Separator 93327
 
3.2%
Decimal Number 13498
 
0.5%
Other Punctuation 6625
 
0.2%
Close Punctuation 3875
 
0.1%
Open Punctuation 3875
 
0.1%
Dash Punctuation 3421
 
0.1%
Connector Punctuation 3
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
R 185025
48.6%
S 60728
 
15.9%
G 35411
 
9.3%
C 13097
 
3.4%
D 10420
 
2.7%
F 8709
 
2.3%
A 8251
 
2.2%
Y 8161
 
2.1%
T 7034
 
1.8%
E 5932
 
1.6%
Other values (16) 38223
 
10.0%
Lowercase Letter
ValueCountFrequency (%)
t 403310
16.7%
a 403088
16.7%
r 328107
13.6%
e 308666
12.8%
s 202928
8.4%
n 201353
8.4%
u 181316
7.5%
o 118469
 
4.9%
c 70719
 
2.9%
y 50865
 
2.1%
Other values (14) 140682
 
5.8%
Decimal Number
ValueCountFrequency (%)
2 7151
53.0%
6 3850
28.5%
1 841
 
6.2%
5 728
 
5.4%
8 703
 
5.2%
0 109
 
0.8%
3 98
 
0.7%
4 16
 
0.1%
7 2
 
< 0.1%
Other Punctuation
ValueCountFrequency (%)
' 5812
87.7%
/ 743
 
11.2%
& 42
 
0.6%
. 22
 
0.3%
, 6
 
0.1%
Space Separator
ValueCountFrequency (%)
93327
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3875
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3875
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3421
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 2790494
95.7%
Common 124624
 
4.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
t 403310
14.5%
a 403088
14.4%
r 328107
11.8%
e 308666
11.1%
s 202928
7.3%
n 201353
7.2%
R 185025
6.6%
u 181316
6.5%
o 118469
 
4.2%
c 70719
 
2.5%
Other values (40) 387513
13.9%
Common
ValueCountFrequency (%)
93327
74.9%
2 7151
 
5.7%
' 5812
 
4.7%
) 3875
 
3.1%
( 3875
 
3.1%
6 3850
 
3.1%
- 3421
 
2.7%
1 841
 
0.7%
/ 743
 
0.6%
5 728
 
0.6%
Other values (9) 1001
 
0.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2915118
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
t 403310
13.8%
a 403088
13.8%
r 328107
11.3%
e 308666
10.6%
s 202928
7.0%
n 201353
6.9%
R 185025
 
6.3%
u 181316
 
6.2%
o 118469
 
4.1%
93327
 
3.2%
Other values (59) 489529
16.8%

Risk
Categorical

Distinct4
Distinct (%)< 0.1%
Missing81
Missing (%)< 0.1%
Memory size2.0 MiB
Risk 1 (High)
196108 
Risk 2 (Medium)
49570 
Risk 3 (Low)
21800 
All
 
54

Length

Max length15
Median length13
Mean length13.287068
Min length3

Characters and Unicode

Total characters3554716
Distinct characters23
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowRisk 1 (High)
2nd rowRisk 3 (Low)
3rd rowRisk 1 (High)
4th rowRisk 1 (High)
5th rowRisk 1 (High)

Common Values

ValueCountFrequency (%)
Risk 1 (High) 196108
73.3%
Risk 2 (Medium) 49570
 
18.5%
Risk 3 (Low) 21800
 
8.1%
All 54
 
< 0.1%
(Missing) 81
 
< 0.1%

Length

2024-02-22T09:55:12.716712image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-02-22T09:55:12.880322image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
ValueCountFrequency (%)
risk 267478
33.3%
1 196108
24.4%
high 196108
24.4%
2 49570
 
6.2%
medium 49570
 
6.2%
3 21800
 
2.7%
low 21800
 
2.7%
all 54
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
534956
15.0%
i 513156
14.4%
R 267478
7.5%
s 267478
7.5%
k 267478
7.5%
( 267478
7.5%
) 267478
7.5%
1 196108
 
5.5%
H 196108
 
5.5%
g 196108
 
5.5%
Other values (13) 580890
16.3%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1682316
47.3%
Uppercase Letter 535010
 
15.1%
Space Separator 534956
 
15.0%
Open Punctuation 267478
 
7.5%
Close Punctuation 267478
 
7.5%
Decimal Number 267478
 
7.5%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
i 513156
30.5%
s 267478
15.9%
k 267478
15.9%
g 196108
 
11.7%
h 196108
 
11.7%
d 49570
 
2.9%
m 49570
 
2.9%
u 49570
 
2.9%
e 49570
 
2.9%
o 21800
 
1.3%
Other values (2) 21908
 
1.3%
Uppercase Letter
ValueCountFrequency (%)
R 267478
50.0%
H 196108
36.7%
M 49570
 
9.3%
L 21800
 
4.1%
A 54
 
< 0.1%
Decimal Number
ValueCountFrequency (%)
1 196108
73.3%
2 49570
 
18.5%
3 21800
 
8.2%
Space Separator
ValueCountFrequency (%)
534956
100.0%
Open Punctuation
ValueCountFrequency (%)
( 267478
100.0%
Close Punctuation
ValueCountFrequency (%)
) 267478
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 2217326
62.4%
Common 1337390
37.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
i 513156
23.1%
R 267478
12.1%
s 267478
12.1%
k 267478
12.1%
H 196108
 
8.8%
g 196108
 
8.8%
h 196108
 
8.8%
d 49570
 
2.2%
m 49570
 
2.2%
u 49570
 
2.2%
Other values (7) 164702
 
7.4%
Common
ValueCountFrequency (%)
534956
40.0%
( 267478
20.0%
) 267478
20.0%
1 196108
 
14.7%
2 49570
 
3.7%
3 21800
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 3554716
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
534956
15.0%
i 513156
14.4%
R 267478
7.5%
s 267478
7.5%
k 267478
7.5%
( 267478
7.5%
) 267478
7.5%
1 196108
 
5.5%
H 196108
 
5.5%
g 196108
 
5.5%
Other values (13) 580890
16.3%
Distinct19644
Distinct (%)7.3%
Missing0
Missing (%)0.0%
Memory size2.0 MiB
2024-02-22T09:55:13.484398image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length52
Median length40
Mean length18.610168
Min length1

Characters and Unicode

Total characters4980323
Distinct characters72
Distinct categories10 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2052 ?
Unique (%)0.8%

Sample

1st row6808 N SHERIDAN RD
2nd row1142 W GRAND AVE
3rd row1343 N CALIFORNIA AVE
4th row658 N ASHLAND AVE
5th row2273 N LINCOLN AVE
ValueCountFrequency (%)
ave 123942
 
11.4%
w 106324
 
9.8%
st 97014
 
8.9%
n 80254
 
7.4%
s 59325
 
5.5%
e 21656
 
2.0%
rd 15966
 
1.5%
clark 9481
 
0.9%
western 6759
 
0.6%
halsted 6702
 
0.6%
Other values (8741) 557608
51.4%
2024-02-22T09:55:14.280822image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1085484
21.8%
E 303525
 
6.1%
A 287922
 
5.8%
S 245455
 
4.9%
N 209089
 
4.2%
T 204998
 
4.1%
1 201629
 
4.0%
0 163739
 
3.3%
R 159088
 
3.2%
W 155813
 
3.1%
Other values (62) 1963581
39.4%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 2570593
51.6%
Decimal Number 1199275
24.1%
Space Separator 1085484
21.8%
Lowercase Letter 86621
 
1.7%
Dash Punctuation 26089
 
0.5%
Close Punctuation 5503
 
0.1%
Open Punctuation 5503
 
0.1%
Other Punctuation 1252
 
< 0.1%
Math Symbol 2
 
< 0.1%
Modifier Symbol 1
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
E 303525
11.8%
A 287922
11.2%
S 245455
 
9.5%
N 209089
 
8.1%
T 204998
 
8.0%
R 159088
 
6.2%
W 155813
 
6.1%
V 149459
 
5.8%
L 123732
 
4.8%
O 111553
 
4.3%
Other values (16) 619959
24.1%
Lowercase Letter
ValueCountFrequency (%)
a 9746
11.3%
e 9136
10.5%
t 7878
9.1%
n 7562
8.7%
r 7288
8.4%
o 6601
 
7.6%
i 6345
 
7.3%
l 6147
 
7.1%
h 4215
 
4.9%
s 3546
 
4.1%
Other values (15) 18157
21.0%
Decimal Number
ValueCountFrequency (%)
1 201629
16.8%
0 163739
13.7%
2 146252
12.2%
3 145225
12.1%
5 139561
11.6%
4 120687
10.1%
6 88321
7.4%
7 74378
 
6.2%
8 59776
 
5.0%
9 59707
 
5.0%
Other Punctuation
ValueCountFrequency (%)
/ 720
57.5%
. 369
29.5%
& 133
 
10.6%
' 27
 
2.2%
# 3
 
0.2%
Space Separator
ValueCountFrequency (%)
1085484
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 26089
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5503
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5503
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 2657214
53.4%
Common 2323109
46.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
E 303525
11.4%
A 287922
10.8%
S 245455
 
9.2%
N 209089
 
7.9%
T 204998
 
7.7%
R 159088
 
6.0%
W 155813
 
5.9%
V 149459
 
5.6%
L 123732
 
4.7%
O 111553
 
4.2%
Other values (41) 706580
26.6%
Common
ValueCountFrequency (%)
1085484
46.7%
1 201629
 
8.7%
0 163739
 
7.0%
2 146252
 
6.3%
3 145225
 
6.3%
5 139561
 
6.0%
4 120687
 
5.2%
6 88321
 
3.8%
7 74378
 
3.2%
8 59776
 
2.6%
Other values (11) 98057
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4980323
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1085484
21.8%
E 303525
 
6.1%
A 287922
 
5.8%
S 245455
 
4.9%
N 209089
 
4.2%
T 204998
 
4.1%
1 201629
 
4.0%
0 163739
 
3.3%
R 159088
 
3.2%
W 155813
 
3.1%
Other values (62) 1963581
39.4%

City
Text

Distinct79
Distinct (%)< 0.1%
Missing161
Missing (%)0.1%
Memory size2.0 MiB
2024-02-22T09:55:14.624095image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length20
Median length7
Mean length7.0028267
Min length2

Characters and Unicode

Total characters1872920
Distinct characters44
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique34 ?
Unique (%)< 0.1%

Sample

1st rowCHICAGO
2nd rowCHICAGO
3rd rowCHICAGO
4th rowCHICAGO
5th rowCHICAGO
ValueCountFrequency (%)
chicago 267135
99.8%
cchicago 55
 
< 0.1%
schaumburg 28
 
< 0.1%
park 19
 
< 0.1%
evanston 18
 
< 0.1%
maywood 16
 
< 0.1%
grove 14
 
< 0.1%
niles 14
 
< 0.1%
elk 13
 
< 0.1%
village 13
 
< 0.1%
Other values (80) 219
 
0.1%
2024-02-22T09:55:15.123198image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
C 533911
28.5%
A 266838
14.2%
I 266801
14.2%
O 266800
14.2%
H 266762
14.2%
G 266736
14.2%
c 717
 
< 0.1%
o 579
 
< 0.1%
i 578
 
< 0.1%
a 578
 
< 0.1%
Other values (34) 2620
 
0.1%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 1869216
99.8%
Lowercase Letter 3595
 
0.2%
Space Separator 92
 
< 0.1%
Decimal Number 12
 
< 0.1%
Other Punctuation 5
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
C 533911
28.6%
A 266838
14.3%
I 266801
14.3%
O 266800
14.3%
H 266762
14.3%
G 266736
14.3%
E 213
 
< 0.1%
L 146
 
< 0.1%
R 145
 
< 0.1%
S 122
 
< 0.1%
Other values (15) 742
 
< 0.1%
Lowercase Letter
ValueCountFrequency (%)
c 717
19.9%
o 579
16.1%
i 578
16.1%
a 578
16.1%
g 577
16.1%
h 556
15.5%
d 2
 
0.1%
r 2
 
0.1%
s 1
 
< 0.1%
l 1
 
< 0.1%
Other values (4) 4
 
0.1%
Decimal Number
ValueCountFrequency (%)
3 4
33.3%
1 4
33.3%
2 4
33.3%
Space Separator
ValueCountFrequency (%)
92
100.0%
Other Punctuation
ValueCountFrequency (%)
. 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1872811
> 99.9%
Common 109
 
< 0.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
C 533911
28.5%
A 266838
14.2%
I 266801
14.2%
O 266800
14.2%
H 266762
14.2%
G 266736
14.2%
c 717
 
< 0.1%
o 579
 
< 0.1%
i 578
 
< 0.1%
a 578
 
< 0.1%
Other values (29) 2511
 
0.1%
Common
ValueCountFrequency (%)
92
84.4%
. 5
 
4.6%
3 4
 
3.7%
1 4
 
3.7%
2 4
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1872920
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
C 533911
28.5%
A 266838
14.2%
I 266801
14.2%
O 266800
14.2%
H 266762
14.2%
G 266736
14.2%
c 717
 
< 0.1%
o 579
 
< 0.1%
i 578
 
< 0.1%
a 578
 
< 0.1%
Other values (34) 2620
 
0.1%

State
Categorical

IMBALANCE 

Distinct5
Distinct (%)< 0.1%
Missing59
Missing (%)< 0.1%
Memory size2.0 MiB
IL
267543 
IN
 
7
CA
 
2
NY
 
1
WI
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Characters and Unicode

Total characters535108
Distinct characters7
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st rowIL
2nd rowIL
3rd rowIL
4th rowIL
5th rowIL

Common Values

ValueCountFrequency (%)
IL 267543
> 99.9%
IN 7
 
< 0.1%
CA 2
 
< 0.1%
NY 1
 
< 0.1%
WI 1
 
< 0.1%
(Missing) 59
 
< 0.1%

Length

2024-02-22T09:55:15.294033image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-02-22T09:55:15.426807image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
ValueCountFrequency (%)
il 267543
> 99.9%
in 7
 
< 0.1%
ca 2
 
< 0.1%
ny 1
 
< 0.1%
wi 1
 
< 0.1%

Most occurring characters

ValueCountFrequency (%)
I 267551
50.0%
L 267543
50.0%
N 8
 
< 0.1%
C 2
 
< 0.1%
A 2
 
< 0.1%
Y 1
 
< 0.1%
W 1
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 535108
100.0%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
I 267551
50.0%
L 267543
50.0%
N 8
 
< 0.1%
C 2
 
< 0.1%
A 2
 
< 0.1%
Y 1
 
< 0.1%
W 1
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Latin 535108
100.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
I 267551
50.0%
L 267543
50.0%
N 8
 
< 0.1%
C 2
 
< 0.1%
A 2
 
< 0.1%
Y 1
 
< 0.1%
W 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 535108
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
I 267551
50.0%
L 267543
50.0%
N 8
 
< 0.1%
C 2
 
< 0.1%
A 2
 
< 0.1%
Y 1
 
< 0.1%
W 1
 
< 0.1%

Zip
Real number (ℝ)

SKEWED 

Distinct121
Distinct (%)< 0.1%
Missing49
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean60628.704
Minimum10014
Maximum90504
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 MiB
2024-02-22T09:55:15.588142image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum10014
5-th percentile60605
Q160614
median60625
Q360643
95-th percentile60659
Maximum90504
Range80490
Interquartile range (IQR)29

Descriptive statistics

Standard deviation148.85738
Coefficient of variation (CV)0.0024552294
Kurtosis63948.539
Mean60628.704
Median Absolute Deviation (MAD)14
Skewness-111.18471
Sum1.6222059 × 1010
Variance22158.518
MonotonicityNot monotonic
2024-02-22T09:55:15.793306image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
60614 9855
 
3.7%
60647 9783
 
3.7%
60657 9076
 
3.4%
60618 8417
 
3.1%
60611 8352
 
3.1%
60622 8183
 
3.1%
60608 8121
 
3.0%
60625 7568
 
2.8%
60607 7349
 
2.7%
60640 7186
 
2.7%
Other values (111) 183674
68.6%
ValueCountFrequency (%)
10014 1
 
< 0.1%
46319 1
 
< 0.1%
46394 1
 
< 0.1%
46410 5
 
< 0.1%
53061 1
 
< 0.1%
60007 13
< 0.1%
60015 2
 
< 0.1%
60018 4
 
< 0.1%
60022 1
 
< 0.1%
60035 3
 
< 0.1%
ValueCountFrequency (%)
90504 1
 
< 0.1%
90067 1
 
< 0.1%
60827 220
 
0.1%
60805 4
 
< 0.1%
60804 9
 
< 0.1%
60803 3
 
< 0.1%
60714 7
 
< 0.1%
60707 1542
0.6%
60706 4
 
< 0.1%
60666 3336
1.2%
Distinct3564
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size2.0 MiB
Minimum2010-01-04 00:00:00
Maximum2024-02-14 00:00:00
2024-02-22T09:55:15.998175image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:16.331116image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct110
Distinct (%)< 0.1%
Missing1
Missing (%)< 0.1%
Memory size2.0 MiB
2024-02-22T09:55:16.590005image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length41
Median length7
Mean length10.645576
Min length3

Characters and Unicode

Total characters2848884
Distinct characters61
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique69 ?
Unique (%)< 0.1%

Sample

1st rowLicense
2nd rowLicense
3rd rowCanvass
4th rowCanvass
5th rowLicense
ValueCountFrequency (%)
canvass 168556
49.3%
re-inspection 51816
 
15.1%
license 47234
 
13.8%
complaint 44291
 
12.9%
short 8425
 
2.5%
form 8425
 
2.5%
non-inspection 2827
 
0.8%
suspected 1190
 
0.3%
food 1190
 
0.3%
poisoning 1190
 
0.3%
Other values (122) 7061
 
2.1%
2024-02-22T09:55:17.052148image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
s 445026
15.6%
a 384730
13.5%
n 378685
13.3%
C 213967
 
7.5%
e 208249
 
7.3%
v 169284
 
5.9%
i 151929
 
5.3%
o 127691
 
4.5%
t 111696
 
3.9%
c 105564
 
3.7%
Other values (51) 552063
19.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 2318985
81.4%
Uppercase Letter 398319
 
14.0%
Space Separator 74593
 
2.6%
Dash Punctuation 55590
 
2.0%
Decimal Number 1245
 
< 0.1%
Close Punctuation 67
 
< 0.1%
Open Punctuation 66
 
< 0.1%
Other Punctuation 19
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
s 445026
19.2%
a 384730
16.6%
n 378685
16.3%
e 208249
9.0%
v 169284
 
7.3%
i 151929
 
6.6%
o 127691
 
5.5%
t 111696
 
4.8%
c 105564
 
4.6%
p 100980
 
4.4%
Other values (13) 135151
 
5.8%
Uppercase Letter
ValueCountFrequency (%)
C 213967
53.7%
I 54970
 
13.8%
R 53002
 
13.3%
L 48192
 
12.1%
F 10925
 
2.7%
S 9883
 
2.5%
N 3059
 
0.8%
T 1585
 
0.4%
P 1296
 
0.3%
O 441
 
0.1%
Other values (13) 999
 
0.3%
Decimal Number
ValueCountFrequency (%)
4 359
28.8%
1 313
25.1%
7 306
24.6%
5 255
20.5%
8 5
 
0.4%
0 5
 
0.4%
6 1
 
0.1%
3 1
 
0.1%
Other Punctuation
ValueCountFrequency (%)
/ 15
78.9%
. 3
 
15.8%
' 1
 
5.3%
Space Separator
ValueCountFrequency (%)
74593
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 55590
100.0%
Close Punctuation
ValueCountFrequency (%)
) 67
100.0%
Open Punctuation
ValueCountFrequency (%)
( 66
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 2717304
95.4%
Common 131580
 
4.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
s 445026
16.4%
a 384730
14.2%
n 378685
13.9%
C 213967
7.9%
e 208249
7.7%
v 169284
 
6.2%
i 151929
 
5.6%
o 127691
 
4.7%
t 111696
 
4.1%
c 105564
 
3.9%
Other values (36) 420483
15.5%
Common
ValueCountFrequency (%)
74593
56.7%
- 55590
42.2%
4 359
 
0.3%
1 313
 
0.2%
7 306
 
0.2%
5 255
 
0.2%
) 67
 
0.1%
( 66
 
0.1%
/ 15
 
< 0.1%
8 5
 
< 0.1%
Other values (5) 11
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2848884
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
s 445026
15.6%
a 384730
13.5%
n 378685
13.3%
C 213967
 
7.5%
e 208249
 
7.3%
v 169284
 
5.9%
i 151929
 
5.3%
o 127691
 
4.5%
t 111696
 
3.9%
c 105564
 
3.7%
Other values (51) 552063
19.4%

Results
Categorical

Distinct7
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size2.0 MiB
Pass
137779 
Fail
52283 
Pass w/ Conditions
40757 
Out of Business
22619 
No Entry
 
10694
Other values (2)
 
3481

Length

Max length20
Median length4
Mean length7.290326
Min length4

Characters and Unicode

Total characters1950986
Distinct characters26
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowNot Ready
2nd rowPass
3rd rowPass
4th rowFail
5th rowNot Ready

Common Values

ValueCountFrequency (%)
Pass 137779
51.5%
Fail 52283
 
19.5%
Pass w/ Conditions 40757
 
15.2%
Out of Business 22619
 
8.5%
No Entry 10694
 
4.0%
Not Ready 3395
 
1.3%
Business Not Located 86
 
< 0.1%

Length

2024-02-22T09:55:17.250982image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-02-22T09:55:17.415553image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
ValueCountFrequency (%)
pass 178536
43.7%
fail 52283
 
12.8%
w 40757
 
10.0%
conditions 40757
 
10.0%
business 22705
 
5.6%
out 22619
 
5.5%
of 22619
 
5.5%
no 10694
 
2.6%
entry 10694
 
2.6%
not 3481
 
0.9%
Other values (2) 3481
 
0.9%

Most occurring characters

ValueCountFrequency (%)
s 465944
23.9%
a 234300
12.0%
P 178536
 
9.2%
i 156502
 
8.0%
141013
 
7.2%
o 118394
 
6.1%
n 114913
 
5.9%
t 77637
 
4.0%
l 52283
 
2.7%
F 52283
 
2.7%
Other values (16) 359181
18.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1423966
73.0%
Uppercase Letter 345250
 
17.7%
Space Separator 141013
 
7.2%
Other Punctuation 40757
 
2.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
s 465944
32.7%
a 234300
16.5%
i 156502
 
11.0%
o 118394
 
8.3%
n 114913
 
8.1%
t 77637
 
5.5%
l 52283
 
3.7%
u 45324
 
3.2%
d 44238
 
3.1%
w 40757
 
2.9%
Other values (5) 73674
 
5.2%
Uppercase Letter
ValueCountFrequency (%)
P 178536
51.7%
F 52283
 
15.1%
C 40757
 
11.8%
B 22705
 
6.6%
O 22619
 
6.6%
N 14175
 
4.1%
E 10694
 
3.1%
R 3395
 
1.0%
L 86
 
< 0.1%
Space Separator
ValueCountFrequency (%)
141013
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 40757
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1769216
90.7%
Common 181770
 
9.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
s 465944
26.3%
a 234300
13.2%
P 178536
 
10.1%
i 156502
 
8.8%
o 118394
 
6.7%
n 114913
 
6.5%
t 77637
 
4.4%
l 52283
 
3.0%
F 52283
 
3.0%
u 45324
 
2.6%
Other values (14) 273100
15.4%
Common
ValueCountFrequency (%)
141013
77.6%
/ 40757
 
22.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1950986
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
s 465944
23.9%
a 234300
12.0%
P 178536
 
9.2%
i 156502
 
8.0%
141013
 
7.2%
o 118394
 
6.1%
n 114913
 
5.9%
t 77637
 
4.0%
l 52283
 
2.7%
F 52283
 
2.7%
Other values (16) 359181
18.4%

Violations
Text

MISSING 

Distinct192974
Distinct (%)99.3%
Missing73370
Missing (%)27.4%
Memory size2.0 MiB
2024-02-22T09:55:18.184046image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length11620
Median length5021
Mean length1221.1706
Min length30

Characters and Unicode

Total characters237203849
Distinct characters100
Distinct categories14 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique192057 ?
Unique (%)98.9%

Sample

1st row48. WAREWASHING FACILITIES: INSTALLED, MAINTAINED & USED; TEST STRIPS - Comments: OBSERVED 3-COMPARTMENT SINK NOT IN PROPER WORKING ORDER. WHEN WATER IS DRAINED IN ONE COMPARTMENT, ANOTHER ONE FLOODS BEFORE GOING BACK DOWN. INSTRUCTED MANAGER TO SERVICE 3-COMPARTMENT SINK. PRIORITY FOUNDATION VIOLATION 7-38-025 CITATION ISSUED.
2nd row49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: 4-601.11(C) OBSERVED BUILD-UP OF FOOD DEBRIS ON THE INTERIOR OF THE FREEZER WHERE FROZEN SHRIMP AND BATTER ARE STORED. INSTRUCTED PERSON IN CHARGE TO CLEAN AND MAINTAIN. | 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: 6-201.11 OBSERVED MISSING CEILING TILES IN THE STORAGE ROOM. INSTRUCTED PERSON IN CHARGE TO REPLACE AND MAINTAIN.
3rd row38. INSECTS, RODENTS, & ANIMALS NOT PRESENT - Comments: OBSERVED RODENT ACTIVITY ON PREMISES. FOUND 40-50 MOUSE DROPPINGS ON THE FLOOR UNDER THE STORAGE SHELVES IN THE REAR STORAGE AREA, ALONG THE POTATO CHIP AISLE AND IN STORAGE AREA UNDER SHELVES BY THE WALK-IN COOLER. INSTRUCTED TO CLEAN ALL AREAS AND HAVE PEST CONTROL COMPANY SERVICE PRIOR TO REINSPECTION. PRIORITY FOUNDATION VIOLATION CITATION 7-38-020(A) ISSUED. | 38. INSECTS, RODENTS, & ANIMALS NOT PRESENT - Comments: OBSERVED A 1 INCH GAP AT BOTTOM OF FRONT ENTRANCE DOOR; INSTRUCTED TO RAISE THRESHOLE AND PROVIDE A LONGER DOOR SWEEP. | 47. FOOD & NON-FOOD CONTACT SURFACES CLEANABLE, PROPERLY DESIGNED, CONSTRUCTED & USED - Comments: THE DOOR TO THE WALK IN COOLER IS IN POOR REPAIR; INSTRUCTED TO REPAIR DOOR. (UNIT MAINTAINING AT PROPER TEMPERATURE). | 49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: STORAGE SHELVES ON SELLING FLOOR AND BEHIND FRONT COUNTER NEED CLEANING; CLEAN WHERE NEEDED. | 51. PLUMBING INSTALLED; PROPER BACKFLOW DEVICES - Comments: OBSERVED LEAKING FROM THE CENTERE AREA OF THE FAUCET AT THE THREE COMP SINK; INSTRUCTED TO REPAIR LEAK. | 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: FOUND UNNECESSARY ITEMS IN THE EXPOSED HANDSINK IN THE REAR DISHWASHING AREA; INTRUCTED TO REMOVE AND MAINTAIN SINK FREE OF ITEMS. FOUND THE UTILITY SINK OBSTRUCTED IN REAR DISHWASHING AREA; INSTRUCTED TO ENSURE SINK IS ACCESSIBLE AT ALL TIMES FOR USE. | 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: THE FLOORS AND WALLS AROUND UNDER AND BEHIND VARIOUS EQUIPMENT NEED CLEANING; INSRUCTED TO CLEAN. CLEAN CEILING VENTS AND INTERIORS OF LIGHT SHIELDS IN FOOD PREP AREA. CLEAN FLOOR INSIDE OF WALK-IN COOLER. | 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: SOME WATER STAINED CEILING TILE IN REAR AREA; INSTRUCTED TO REPLACE WHERE NEEDED.
4th row57. ALL FOOD EMPLOYEES HAVE FOOD HANDLER TRAINING - Comments: UNABLE TO LOCATE AND VERIFY FOOD HANDLER CERTIFICATES DURING INSPECTION. MUST PROVIDE AND KEEP CERTIFICATES ON SITE. | 58. ALLERGEN TRAINING AS REQUIRED - Comments: NO ALLERGEN TRAINING FOR CITY OF CHICAGO FOOD MANAGERS. INSTRUCTED MANAGEMENT THAT ALL CITY OF CHICAGO FOOD MANAGERS MUST COMPLETE ALLERGEN TRAINING AND KEEP CERTIFICATE ON SITE.
5th row55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED PEELING PAINT ON CEILING IN DRY STORAGE ROOM/OFFICE REAR AREA. INSTRUCTED PERSON IN CHARGE TO REPAIR AND MAINTAIN.
ValueCountFrequency (%)
1837595
 
5.1%
and 1678537
 
4.7%
comments 899439
 
2.5%
the 828476
 
2.3%
in 754432
 
2.1%
to 705277
 
2.0%
of 647661
 
1.8%
food 630039
 
1.8%
clean 565813
 
1.6%
must 409659
 
1.1%
Other values (196468) 26766686
74.9%
2024-02-22T09:55:19.184492image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
36319340
15.3%
E 19588405
 
8.3%
N 13652588
 
5.8%
O 13571941
 
5.7%
A 13194598
 
5.6%
T 12848957
 
5.4%
I 12542077
 
5.3%
R 11571689
 
4.9%
S 10530603
 
4.4%
D 9236659
 
3.9%
Other values (90) 84146992
35.5%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 163426436
68.9%
Space Separator 36319340
 
15.3%
Lowercase Letter 23284205
 
9.8%
Other Punctuation 6961764
 
2.9%
Decimal Number 4165629
 
1.8%
Dash Punctuation 1974824
 
0.8%
Math Symbol 684641
 
0.3%
Open Punctuation 185344
 
0.1%
Close Punctuation 183184
 
0.1%
Currency Symbol 13992
 
< 0.1%
Other values (4) 4490
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 2949011
12.7%
n 2313553
9.9%
o 2296622
9.9%
t 2164779
9.3%
m 2090390
9.0%
s 2029500
8.7%
a 1526209
 
6.6%
l 1154956
 
5.0%
i 1135659
 
4.9%
r 986277
 
4.2%
Other values (17) 4637249
19.9%
Uppercase Letter
ValueCountFrequency (%)
E 19588405
12.0%
N 13652588
 
8.4%
O 13571941
 
8.3%
A 13194598
 
8.1%
T 12848957
 
7.9%
I 12542077
 
7.7%
R 11571689
 
7.1%
S 10530603
 
6.4%
D 9236659
 
5.7%
L 7655682
 
4.7%
Other values (16) 39033237
23.9%
Other Punctuation
ValueCountFrequency (%)
. 2993131
43.0%
, 1877964
27.0%
: 1378386
19.8%
& 232499
 
3.3%
/ 231975
 
3.3%
; 116124
 
1.7%
# 59923
 
0.9%
' 52062
 
0.7%
* 15485
 
0.2%
@ 2721
 
< 0.1%
Other values (5) 1494
 
< 0.1%
Decimal Number
ValueCountFrequency (%)
3 890062
21.4%
0 613664
14.7%
5 506318
12.2%
1 498319
12.0%
4 397239
9.5%
2 395795
9.5%
8 309877
 
7.4%
7 280732
 
6.7%
6 167692
 
4.0%
9 105931
 
2.5%
Math Symbol
ValueCountFrequency (%)
| 684246
99.9%
= 292
 
< 0.1%
+ 76
 
< 0.1%
> 18
 
< 0.1%
~ 5
 
< 0.1%
< 4
 
< 0.1%
Open Punctuation
ValueCountFrequency (%)
( 185089
99.9%
[ 243
 
0.1%
{ 12
 
< 0.1%
Close Punctuation
ValueCountFrequency (%)
) 182982
99.9%
] 190
 
0.1%
} 12
 
< 0.1%
Control
ValueCountFrequency (%)
3919
99.9%
 2
 
0.1%
 1
 
< 0.1%
Modifier Symbol
ValueCountFrequency (%)
` 13
81.2%
^ 3
 
18.8%
Space Separator
ValueCountFrequency (%)
36319340
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1974824
100.0%
Currency Symbol
ValueCountFrequency (%)
$ 13992
100.0%
Other Number
ValueCountFrequency (%)
½ 483
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 69
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 186710641
78.7%
Common 50493208
 
21.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
E 19588405
 
10.5%
N 13652588
 
7.3%
O 13571941
 
7.3%
A 13194598
 
7.1%
T 12848957
 
6.9%
I 12542077
 
6.7%
R 11571689
 
6.2%
S 10530603
 
5.6%
D 9236659
 
4.9%
L 7655682
 
4.1%
Other values (43) 62317442
33.4%
Common
ValueCountFrequency (%)
36319340
71.9%
. 2993131
 
5.9%
- 1974824
 
3.9%
, 1877964
 
3.7%
: 1378386
 
2.7%
3 890062
 
1.8%
| 684246
 
1.4%
0 613664
 
1.2%
5 506318
 
1.0%
1 498319
 
1.0%
Other values (37) 2756954
 
5.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 237202400
> 99.9%
None 1449
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
36319340
15.3%
E 19588405
 
8.3%
N 13652588
 
5.8%
O 13571941
 
5.7%
A 13194598
 
5.6%
T 12848957
 
5.4%
I 12542077
 
5.3%
R 11571689
 
4.9%
S 10530603
 
4.4%
D 9236659
 
3.9%
Other values (87) 84145543
35.5%
None
ValueCountFrequency (%)
ï 483
33.3%
¿ 483
33.3%
½ 483
33.3%

Latitude
Real number (ℝ)

Distinct18214
Distinct (%)6.8%
Missing924
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean41.880731
Minimum41.64467
Maximum42.021064
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.0 MiB
2024-02-22T09:55:19.382632image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum41.64467
5-th percentile41.726944
Q141.831831
median41.89177
Q341.939785
95-th percentile41.997516
Maximum42.021064
Range0.37639412
Interquartile range (IQR)0.10795422

Descriptive statistics

Standard deviation0.08106902
Coefficient of variation (CV)0.0019357117
Kurtosis-0.3540197
Mean41.880731
Median Absolute Deviation (MAD)0.050581061
Skewness-0.58981625
Sum11169130
Variance0.0065721859
MonotonicityNot monotonic
2024-02-22T09:55:19.573309image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
42.00875077 3291
 
1.2%
41.78932932 767
 
0.3%
41.88418751 597
 
0.2%
41.88199434 584
 
0.2%
41.85045102 584
 
0.2%
41.88743405 480
 
0.2%
41.88458627 377
 
0.1%
41.88807428 369
 
0.1%
41.89209414 368
 
0.1%
41.75466012 342
 
0.1%
Other values (18204) 258930
96.8%
(Missing) 924
 
0.3%
ValueCountFrequency (%)
41.64467013 13
< 0.1%
41.64566748 4
 
< 0.1%
41.64637082 7
< 0.1%
41.64655405 2
 
< 0.1%
41.64818878 9
< 0.1%
41.64863829 6
 
< 0.1%
41.64868838 3
 
< 0.1%
41.64874251 2
 
< 0.1%
41.64881845 3
 
< 0.1%
41.64936399 17
< 0.1%
ValueCountFrequency (%)
42.02106425 25
< 0.1%
42.02086075 16
< 0.1%
42.02080848 16
< 0.1%
42.02075289 7
 
< 0.1%
42.02039924 1
 
< 0.1%
42.02008731 15
< 0.1%
42.01986688 21
< 0.1%
42.01958216 20
< 0.1%
42.019494 5
 
< 0.1%
42.0194929 1
 
< 0.1%

Longitude
Real number (ℝ)

Distinct18214
Distinct (%)6.8%
Missing924
Missing (%)0.3%
Infinite0
Infinite (%)0.0%
Mean-87.676338
Minimum-87.906874
Maximum-87.525094
Zeros0
Zeros (%)0.0%
Negative266689
Negative (%)99.7%
Memory size2.0 MiB
2024-02-22T09:55:19.783007image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Quantile statistics

Minimum-87.906874
5-th percentile-87.777776
Q1-87.707489
median-87.666419
Q3-87.634942
95-th percentile-87.59954
Maximum-87.525094
Range0.38178
Interquartile range (IQR)0.072547535

Descriptive statistics

Standard deviation0.05825962
Coefficient of variation (CV)-0.0006644851
Kurtosis2.0977554
Mean-87.676338
Median Absolute Deviation (MAD)0.034445649
Skewness-0.97647509
Sum-23382315
Variance0.0033941833
MonotonicityNot monotonic
2024-02-22T09:55:19.975730image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-87.90687413 3291
 
1.2%
-87.74164564 767
 
0.3%
-87.64111967 597
 
0.2%
-87.63975868 584
 
0.2%
-87.65879786 584
 
0.2%
-87.68184949 480
 
0.2%
-87.63101045 377
 
0.1%
-87.6349552 369
 
0.1%
-87.61156988 368
 
0.1%
-87.74138476 342
 
0.1%
Other values (18204) 258930
96.8%
(Missing) 924
 
0.3%
ValueCountFrequency (%)
-87.90687413 3291
1.2%
-87.90675786 3
 
< 0.1%
-87.90530913 12
 
< 0.1%
-87.88270766 2
 
< 0.1%
-87.86695767 1
 
< 0.1%
-87.86302998 25
 
< 0.1%
-87.86237264 9
 
< 0.1%
-87.84631989 11
 
< 0.1%
-87.84631558 2
 
< 0.1%
-87.8463105 1
 
< 0.1%
ValueCountFrequency (%)
-87.52509414 12
< 0.1%
-87.52512485 16
< 0.1%
-87.52571243 4
 
< 0.1%
-87.5258717 19
< 0.1%
-87.5261364 9
< 0.1%
-87.52664793 20
< 0.1%
-87.52667081 11
< 0.1%
-87.52694018 16
< 0.1%
-87.52749847 2
 
< 0.1%
-87.52770401 3
 
< 0.1%
Distinct18214
Distinct (%)6.8%
Missing924
Missing (%)0.3%
Memory size2.0 MiB
2024-02-22T09:55:20.457063image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Length

Max length40
Median length39
Mean length39.059676
Min length34

Characters and Unicode

Total characters10416786
Distinct characters16
Distinct categories6 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1596 ?
Unique (%)0.6%

Sample

1st row(42.00582694496218, -87.66114012527682)
2nd row(41.89120176033192, -87.6562947219871)
3rd row(41.90598597077873, -87.69680735572291)
4th row(41.894208809612294, -87.66738222845791)
5th row(41.9235739992025, -87.64593222667874)
ValueCountFrequency (%)
42.00875076599798 3291
 
0.6%
87.90687413400109 3291
 
0.6%
41.789329323265385 767
 
0.1%
87.74164564419637 767
 
0.1%
41.884187507127805 597
 
0.1%
87.64111966683218 597
 
0.1%
41.88199433820508 584
 
0.1%
87.6397586848809 584
 
0.1%
41.85045102427 584
 
0.1%
87.65879785567869 584
 
0.1%
Other values (36418) 521732
97.8%
2024-02-22T09:55:21.103835image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8 1078826
10.4%
7 1072048
10.3%
4 988988
9.5%
1 924314
8.9%
6 905875
8.7%
9 808831
7.8%
5 730340
 
7.0%
2 702799
 
6.7%
3 688625
 
6.6%
0 649317
 
6.2%
Other values (6) 1866823
17.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 8549963
82.1%
Other Punctuation 800067
 
7.7%
Open Punctuation 266689
 
2.6%
Space Separator 266689
 
2.6%
Dash Punctuation 266689
 
2.6%
Close Punctuation 266689
 
2.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 1078826
12.6%
7 1072048
12.5%
4 988988
11.6%
1 924314
10.8%
6 905875
10.6%
9 808831
9.5%
5 730340
8.5%
2 702799
8.2%
3 688625
8.1%
0 649317
7.6%
Other Punctuation
ValueCountFrequency (%)
. 533378
66.7%
, 266689
33.3%
Open Punctuation
ValueCountFrequency (%)
( 266689
100.0%
Space Separator
ValueCountFrequency (%)
266689
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 266689
100.0%
Close Punctuation
ValueCountFrequency (%)
) 266689
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 10416786
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
8 1078826
10.4%
7 1072048
10.3%
4 988988
9.5%
1 924314
8.9%
6 905875
8.7%
9 808831
7.8%
5 730340
 
7.0%
2 702799
 
6.7%
3 688625
 
6.6%
0 649317
 
6.2%
Other values (6) 1866823
17.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10416786
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8 1078826
10.4%
7 1072048
10.3%
4 988988
9.5%
1 924314
8.9%
6 905875
8.7%
9 808831
7.8%
5 730340
 
7.0%
2 702799
 
6.7%
3 688625
 
6.6%
0 649317
 
6.2%
Other values (6) 1866823
17.9%

Interactions

2024-02-22T09:55:04.178334image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:54:59.886806image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:01.298343image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:02.249415image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:03.216235image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:04.379221image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:00.515507image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:01.469293image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:02.431309image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:03.390100image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:04.565377image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:00.703453image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:01.673384image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:02.615252image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:03.579556image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:04.756621image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:00.900560image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:01.862561image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:02.815808image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:03.771273image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:04.957031image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:01.101690image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:02.051259image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:03.012370image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
2024-02-22T09:55:03.978432image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/

Missing values

2024-02-22T09:55:05.563639image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-02-22T09:55:06.301403image/svg+xmlMatplotlib v3.8.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

Inspection IDDBA NameAKA NameLicense #Facility TypeRiskAddressCityStateZipInspection DateInspection TypeResultsViolationsLatitudeLongitudeLocation
02589576Drippin' BitesDrippin' Bites2952306.0NaNRisk 1 (High)6808 N SHERIDAN RDCHICAGOIL60626.002/14/2024LicenseNot ReadyNaN42.005827-87.661140(42.00582694496218, -87.66114012527682)
12589517GRAND BEER WINE SPIRITSGRAND BEER WINE SPIRITS2923772.0Grocery StoreRisk 3 (Low)1142 W GRAND AVECHICAGOIL60642.002/13/2024LicensePassNaN41.891202-87.656295(41.89120176033192, -87.6562947219871)
22589485CASA CENTRAL COMMUNITY SERVICECASA CENTRAL COMMUNITY SERVICE60765.0RestaurantRisk 1 (High)1343 N CALIFORNIA AVECHICAGOIL60622.002/13/2024CanvassPassNaN41.905986-87.696807(41.90598597077873, -87.69680735572291)
32589362BARTOLI'S PIZZERIABARTOLI'S PIZZERIA2709388.0RestaurantRisk 1 (High)658 N ASHLAND AVECHICAGOIL60622.002/08/2024CanvassFail48. WAREWASHING FACILITIES: INSTALLED, MAINTAINED & USED; TEST STRIPS - Comments: OBSERVED 3-COMPARTMENT SINK NOT IN PROPER WORKING ORDER. WHEN WATER IS DRAINED IN ONE COMPARTMENT, ANOTHER ONE FLOODS BEFORE GOING BACK DOWN. INSTRUCTED MANAGER TO SERVICE 3-COMPARTMENT SINK. PRIORITY FOUNDATION VIOLATION 7-38-025 CITATION ISSUED.41.894209-87.667382(41.894208809612294, -87.66738222845791)
42589343LUNCH HEROSLUNCH HEROS2951905.0RestaurantRisk 1 (High)2273 N LINCOLN AVECHICAGOIL60614.002/08/2024LicenseNot ReadyNaN41.923574-87.645932(41.9235739992025, -87.64593222667874)
52589341BurkeBurke22411.0SchoolRisk 1 (High)5356 S DR MARTIN LUTHER KING JR DRCHICAGOIL60615.002/08/2024CanvassPassNaN41.796793-87.616178(41.79679284535837, -87.61617809193172)
62589328MORITAS TACOS INC.MORITAS TACOS INC.2757311.0RestaurantRisk 1 (High)11436 S MICHIGAN AVECHICAGOIL60628.002/07/2024CanvassOut of BusinessNaN41.686017-87.620976(41.68601702970069, -87.62097609686657)
72589311Qdoba Mexican Eats #2628Qdoba Mexican Eats #26282017847.0RestaurantRisk 1 (High)957 W DIVERSEY PKWYCHICAGOIL60614.002/07/2024CanvassOut of BusinessNaN41.932531-87.653709(41.93253117623138, -87.65370947965262)
82589307La Grande Boucherie / Omakase RoomLa Grande Boucherie / Omakase Room2948461.0RestaurantRisk 3 (Low)431 N DEARBORN STCHICAGOIL60654.002/07/2024License Re-InspectionPassNaN41.890082-87.629462(41.89008217360064, -87.6294615287741)
92589293RED LOBSTER #0277RED LOBSTER2333153.0RestaurantRisk 1 (High)5201 S PULASKI RDCHICAGOIL60632.002/07/2024Canvass Re-InspectionPass49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: 4-601.11(C)\t OBSERVED BUILD-UP OF FOOD DEBRIS ON THE INTERIOR OF THE FREEZER WHERE FROZEN SHRIMP AND BATTER ARE STORED. INSTRUCTED PERSON IN CHARGE TO CLEAN AND MAINTAIN. | 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: 6-201.11 OBSERVED MISSING CEILING TILES IN THE STORAGE ROOM. INSTRUCTED PERSON IN CHARGE TO REPLACE AND MAINTAIN.41.798510-87.723165(41.79850994776847, -87.72316542310595)
Inspection IDDBA NameAKA NameLicense #Facility TypeRiskAddressCityStateZipInspection DateInspection TypeResultsViolationsLatitudeLongitudeLocation
26760358271CarpenterCarpenter22561.0SchoolRisk 1 (High)1250 W Erie STCHICAGOIL60622.001/25/2010CanvassPass32. FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: All food and non-food contact equipment and utensils shall be smooth, easily cleanable, and durable, and shall be in good repair.PEELING PAINT ON MULTI-USE ITENSIL HANGING RACK AT FOOD PREP TABLE MUST REPAIR. | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: The floors shall be constructed per code, be smooth and easily cleaned, and be kept clean and in good repair.FLOORS IN UTILITY MOP SINK CLOSETS REQUIRE DETAIL CLEANING. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: Ventilation: All plumbing fixtures, such as toilets, sinks, washbasins, etc., must be adequately trapped, vented, and re-vented and properly connected to the sewer in accordance with the plumbing chapter of the Municipal Code of Chicago and the Rules and Regulations of the Board of Health.EXHAUST FAN ON KITCHEN WALL REQUIRES DETAIL CLEANING.41.893576-87.659367(41.893575701813866, -87.65936675601802)
267604118299HALSTED FOODSHALSTED FOODS1842450.0Grocery StoreRisk 2 (Medium)3418 S HALSTED STCHICAGOIL60608.001/06/2010Short Form ComplaintFail16. FOOD PROTECTED DURING STORAGE, PREPARATION, DISPLAY, SERVICE AND TRANSPORTATION - Comments: All food should be properly protected from contamination during storage, preparation, display, service, and transportation. FOUND MEAT SAW BLADE ENCRUSTED WITH DRY AND FRESH RAW BEEF/PORK THROUGHOUT SAID BLADE AT BUTCHER PREP AREA. INSTRUCTED TO CLEAN AND SANITIZE SAID MEAT SAW BLADE BEFORE REUSING FOR RAW FRESH MEATS. SERIOUS 7-38-005(A) ISSUED. | 18. NO EVIDENCE OF RODENT OR INSECT OUTER OPENINGS PROTECTED/RODENT PROOFED, A WRITTEN LOG SHALL BE MAINTAINED AVAILABLE TO THE INSPECTORS - Comments: All necessary control measures shall be used to effectively minimize or eliminate the presence of rodents, roaches, and other vermin and insects on the premises of all food establishments, in food-transporting vehicles, and in vending machines. FOUND FRONT ENTRANCE DOOR NOT RODENT PROOFED, APPROXIMATELY 1/4 INCH GAP UNDER SAID DOOR AT RIGHT SIDE AND REAR EXIT DOORS LEADING TO OUTSIDE GARBAGE AREA WITH 1/4 INCH GAP BETWEEN DOORS. INSTRUCTED TO RODENT AND INSECT PROOF SAID DOORS AND MAKE TIGHT FITTING. INCOMPLETE PEST CONTROL LOG BOOK. INSTRUCTED TO PROVIDE ALL REQUIRED DOCUMENTATION IN CURRENT LOG BOOK AND MAINTAIN. ALSO, FOUND 5-7 MOUSE DROPPINGS AT REAR BAKERY AREA ALONG WALL. SERIOUS 7-38-020 ISSUED. | 32. FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: All food and non-food contact equipment and utensils shall be smooth, easily cleanable, and durable, and shall be in good repair. INSTRUCTED TO DEFROST CHEST FREEZER, WALK IN FREEZER, AND REMOVE ICE BUILDUP AT COMPRESSORS ABOVE BUTCHER PREP AREA. INSTRUCTED TO PAINT RUSTED SHELVES, RACKS, EQUIPMENT, EXTERIOR GREASE TRAPS. INSTRUCTED TO REMOVE CARDBOARD LINING AND PAPER LINING FROM SHELVES/RACKS. | 33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: All food and non-food contact surfaces of equipment and all food storage utensils shall be thoroughly cleaned and sanitized daily. INSTRUCTED TO DETAIL CLEAN AND SANITIZE TEH FOLLOWING: SHELVES IN FOOD AISLES, REACH IN COOLERS, WALK IN COOLER, SHELVES/RACKS THROUGHOUT PREMISES, FAN GRID COVERS, WALL AND CEILING AT BAKERY AREA, LIGHT SHIELDS, CASHIER CUBICLES, UNDER, AROUND ALL ITEMS AND EQUIPMENT TO REMOVE DUST, DIRT, DEBRIS, ETC. | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: The floors shall be constructed per code, be smooth and easily cleaned, and be kept clean and in good repair. INSTRUCTED TO REPAIR CRACKED FLOOR TILES AND PROVIDE FLOOR TILES FOR MISSING SECTIONS AT STORAGE AND PREP AREAS. INSTRUCTED TO REMOVE STANDING WATER BY UTILITY SINK. FLOORS ALONG WALL BASE MUST BE DETAIL CLEANED AND MAINTINED. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: The walls and ceilings shall be in good repair and easily cleaned. INSTRUCTED TO REPAIR WALL SECTIONS AROUND PREP TABLES, THREE COMPARTMENT SINK, CLEAN WALLS IN TOILET ROOMS AND WALLS AT WAREHOUSE AREA WITH SPILLS. | 36. LIGHTING: REQUIRED MINIMUM FOOT-CANDLES OF LIGHT PROVIDED, FIXTURES SHIELDED - Comments: Shielding to protect against broken glass falling into food shall be provided for all artificial lighting sources in preparation, service, and display facilities. INSTRUCTED TO PROVIDE LIGHT SHIELDS WITH END CAPS ABOVE DELI PREP AREA. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: Ventilation: All plumbing fixtures, such as toilets, sinks, washbasins, etc., must be adequately trapped, vented, and re-vented and properly connected to the sewer in accordance with the plumbing chapter of the Municipal Code of Chicago and the Rules and Regulations of the Board of Health. INSTRUCTED TO PROVIDE VENTILATION IN TOILET ROOOMS. INSTRUCTED TO PROVIDE PROPERLY CONNECTED FAUCET WITH HOT AND COLD RUNNING WATER AT UTILITY SINK AND DRAIN TO FLOOR DRAIN. INSTRUCTED TO PROVIDE BACKFLOW PREVENTION DEVICE AT FAUCET AT UTILITY SINK. | 41. PREMISES MAINTAINED FREE OF LITTER, UNNECESSARY ARTICLES, CLEANING EQUIPMENT PROPERLY STORED - Comments: All parts of the food establishment and all parts of the property used in connection with the operation of the establishment shall be kept neat and clean and should not produce any offensive odors. INSTRUCTED TO CLEAN AROUND OUTSIDE GARBAGE AREA TO REMOVE DEBRIS AND REMOVE UNSUSED EQUIPMENT FROM PREMISES TO PREVENT PEST HARBORAGE. INSTRUCTED TO ELEVATE ALL ITEMS 6 INCHES OFF THE FLOOR AND AWAY FROM THE WALL. INSTRUCTED TO REMOVE COFFEE GRINDER AT FRONT CASHIER AND OR RELOCATE TO HAND SINK ACCESSIBLE FOR HANDWASHING.41.832144-87.646284(41.83214360513917, -87.64628396417302)
26760568023THE BLEEDING HEART BAKERYTHE BLEEDING HEART BAKERY1874242.0BakeryRisk 1 (High)1955 W BELMONT AVECHICAGOIL60657.001/26/2010Complaint Re-InspectionPass33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: All food and non-food contact surfaces of equipment and all food storage utensils shall be thoroughly cleaned and sanitized daily. DETAIL CLEAN THE WIRE STORAGE RACKS IN THE WALK-IN COOLER. | 41. PREMISES MAINTAINED FREE OF LITTER, UNNECESSARY ARTICLES, CLEANING EQUIPMENT PROPERLY STORED - Comments: All parts of the food establishment and all parts of the property used in connection with the operation of the establishment shall be kept neat and clean and should not produce any offensive odors. OBSERVED EXCEESIVE CLUTTER IN THE BASEMENT AREA. REMOVE ANY UNNECESSARY ARTIVLES AND STORE REMAINING ARTICLES AT LEAST 6' OFF OF THE FLOOR.41.939466-87.678082(41.9394659949947, -87.67808189198753)
26760663239SAN JOSE RESTAURANT, INC.SAN JOSE RESTAURANT, INC.1958715.0RestaurantRisk 1 (High)3121 W CERMAK RDCHICAGOIL60623.001/26/2010CanvassPass33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: All utensils shall be thoroughly cleaned and sanitized after each usage. MUST CLEAN-SANITIZE; FRONT COOKING AREA STORAGE SHELVES AND COOKING EQUIPMENT. | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: The floors shall be constructed per code, be smooth and easily cleaned, and be kept clean and in good repair. MUST CLEAN FLOORS THRU-OUT BASEMENT AND UNDER COOKING EQUIPMENT FRONT COOKING AREA. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: The walls and ceilings shall be in good repair and easily cleaned. MUST CLEAN HOOD AND FILTERS ABOVE FRONT AREA COOKING EQUIPMENT.41.851674-87.703788(41.85167408577538, -87.7037875274402)
267607134256BORNIQUEN RESTAURANTBORNIQUEN RESTAURANT32942.0RestaurantRisk 1 (High)1720 N CALIFORNIA AVECHICAGOIL60647.001/13/2010Complaint Re-InspectionPassNaN41.912692-87.697205(41.912691923355744, -87.69720455176802)
267608197240CINNABONCINNABON1846783.0NaNRisk 2 (Medium)151 N MICHIGAN AVECHICAGOIL60601.001/27/2010Out of BusinessFailNaN41.884540-87.624309(41.88454011059238, -87.62430852246028)
267609114316HARD ROCK CAFEHARD ROCK CAFE51236.0RestaurantRisk 1 (High)63 W ONTARIO STCHICAGOIL60654.002/03/2010CanvassPass w/ Conditions21. * CERTIFIED FOOD MANAGER ON SITE WHEN POTENTIALLY HAZARDOUS FOODS ARE PREPARED AND SERVED - Comments: A certified food service manager must be present in all establishments at which potentially hazardous food is prepared or served. No City of Chicago certified food handler on premises while potentially hazardous foods (chicken, beans, burgers, etc.) are handled. Must provide and post City of Chicago certificate on premises with certified food handler while potentially hazardous foods are handled. Citation issued, ticket #H000057364 18. | 32. FOOD AND NON-FOOD CONTACT SURFACES PROPERLY DESIGNED, CONSTRUCTED AND MAINTAINED - Comments: All food and non-food contact equipment and utensils shall be smooth, easily cleanable, and durable, and shall be in good repair. Must replace or repair all damaged prep coolers door rubber gaskets. | 33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: All food and non-food contact surfaces of equipment and all food storage utensils shall be thoroughly cleaned and sanitized daily. Must clean and maintain interior of all unclean prep coolers. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: The walls and ceilings shall be in good repair and easily cleaned. Must detail clean and sanitize walls/ceiling throughout Mezzanine side station. | 38. VENTILATION: ROOMS AND EQUIPMENT VENTED AS REQUIRED: PLUMBING: INSTALLED AND MAINTAINED - Comments: Ventilation: All plumbing fixtures, such as toilets, sinks, washbasins, etc., must be adequately trapped, vented, and re-vented and properly connected to the sewer in accordance with the plumbing chapter of the Municipal Code of Chicago and the Rules and Regulations of the Board of Health. Dishmachine sprayer valve leaking. Must repair and maintain.41.893128-87.630563(41.89312775453658, -87.63056251830054)
26761060258HOOK FISH & CHICKEN ON MADISON, INC.HOOK FISH & CHICKEN ON MADISON, INC.1868125.0RestaurantRisk 2 (Medium)3952 W MONROE STCHICAGOIL60624.001/14/2010Complaint Re-InspectionPassNaN41.879875-87.725290(41.8798749138472, -87.7252903599048)
267611120277POLK STREET CO.POLK STREET CO.29507.0RestaurantRisk 1 (High)548 W POLK STCHICAGOIL60607.001/06/2010CanvassFail18. NO EVIDENCE OF RODENT OR INSECT OUTER OPENINGS PROTECTED/RODENT PROOFED, A WRITTEN LOG SHALL BE MAINTAINED AVAILABLE TO THE INSPECTORS - Comments: All necessary control measures shall be used to effectively minimize or eliminate the presence of rodents, roaches, and other vermin and insects on the premises of all food establishments, in food-transporting vehicles, and in vending machines. Over 25 rat droppings were found in the basement perimeter and holes were found under the stairs and in the old cooler insulation. Clean up and remove all evidence of rodent activity. | 33. FOOD AND NON-FOOD CONTACT EQUIPMENT UTENSILS CLEAN, FREE OF ABRASIVE DETERGENTS - Comments: All food and non-food contact surfaces of equipment and all food storage utensils shall be thoroughly cleaned and sanitized daily. Remove rust from inside the ice machine. | 34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: The floors shall be constructed per code, be smooth and easily cleaned, and be kept clean and in good repair. Clean the floors under the kitchen sink and stoves. Replace the damaged tile under the fryer. | 35. WALLS, CEILINGS, ATTACHED EQUIPMENT CONSTRUCTED PER CODE: GOOD REPAIR, SURFACES CLEAN AND DUST-LESS CLEANING METHODS - Comments: The walls and ceilings shall be in good repair and easily cleaned. Complete repairing the rear kitchen wall and ceiling so they are smooth and sanitary. Repair the damaged ceilings in the basement so rodent harborage can be eliminated.41.872113-87.641305(41.87211261426958, -87.64130525460628)
26761278260DR DETON J BROOKS HEADSTARTDR DETON J BROOKS HEADSTART51035.0Daycare Above and Under 2 YearsRisk 1 (High)6921 S STONY ISLAND AVECHICAGOIL60649.001/15/2010CanvassPass34. FLOORS: CONSTRUCTED PER CODE, CLEANED, GOOD REPAIR, COVING INSTALLED, DUST-LESS CLEANING METHODS USED - Comments: SWEEP FLOORS UNDER STORAGE SHELVES IN KITCHEN PANTRY, BETWEEN LOCKERS BY DRINKING WATER DISPENSER AND STORAGE ROOM NEAR CLASSROOM. | 41. PREMISES MAINTAINED FREE OF LITTER, UNNECESSARY ARTICLES, CLEANING EQUIPMENT PROPERLY STORED - Comments: ORGANIZE AND MAINTAIN STORAGE ROOM ACROSS FROM TEACHERS PREP ROOM.41.769129-87.585827(41.76912914412988, -87.58582746167004)